package data;

import java.sql.Connection;
import java.util.List;

import logic.Product;

public interface IProductDAO {

	//Tirso's methods
	void deleteProductsFromCatalogue(Connection conn, List<String> lp);
	String selectDestinationFromProduct(Connection conn, String idProduct);
	String selectDestinationFromProduct(String idProduct);
	float selectPrice(Connection conn, String idProduct);
	void insertDestinationInProduct(Connection c, String idProduct, String idDestination);
	void insertBuyerInProduct(Connection c, String idProduct, String idBuyer);
	Product selectProduct(String id);
	
	/**
	 * Nando's propierty
	 * @param idUser
	 * @return
	 */
	List<Product> selectProdbyUser(String idUser);
	List<Product> selectNotActive();
	float moneyRaised(String idUser);
	int amountDonate(String idUser);
	int amountDonatedPurchased(String idUser);
	void insert(Product p);
	List<Product> selectNProductNotActive(Integer n);
	void delete(String id);
	public void update(Product p);
}